Entity DefinitionLogical Name : WorkLocation |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| LocationID (FK)(PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | |
| BusinessUnitID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | BusinessUnit(LO_BSN_UN) |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| BusinessUnit | isa | WorkLocation |
| WorkLocation | defines | WorkerAvailability |
| WorkLocation | is location for | JobAllocation |
| WorkLocation | defines location for | Position |
| Location | can be a | WorkLocation |